Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 82580 |
| Missing cells | 3746 |
| Missing cells (%) | 0.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 18.3 MiB |
| Average record size in memory | 232.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 17 |
Nationality has a high cardinality: 188 distinct values | High cardinality |
Unnamed: 0 is highly correlated with ID and 3 other fields | High correlation |
ID is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
DaysSinceCreation is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
AverageLeadTime is highly correlated with BookingsCheckedIn and 3 other fields | High correlation |
BookingsCheckedIn is highly correlated with AverageLeadTime and 5 other fields | High correlation |
PersonsNights is highly correlated with AverageLeadTime and 5 other fields | High correlation |
RoomNights is highly correlated with AverageLeadTime and 5 other fields | High correlation |
DaysSinceLastStay is highly correlated with Unnamed: 0 and 6 other fields | High correlation |
DaysSinceFirstStay is highly correlated with Unnamed: 0 and 6 other fields | High correlation |
Total Revenue is highly correlated with AverageLeadTime and 3 other fields | High correlation |
Unnamed: 0 is highly correlated with ID and 3 other fields | High correlation |
ID is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
DaysSinceCreation is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
BookingsCheckedIn is highly correlated with RoomNights | High correlation |
PersonsNights is highly correlated with RoomNights and 1 other fields | High correlation |
RoomNights is highly correlated with BookingsCheckedIn and 2 other fields | High correlation |
DaysSinceLastStay is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
DaysSinceFirstStay is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
Total Revenue is highly correlated with PersonsNights and 1 other fields | High correlation |
Unnamed: 0 is highly correlated with ID and 3 other fields | High correlation |
ID is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
DaysSinceCreation is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
AverageLeadTime is highly correlated with BookingsCheckedIn and 2 other fields | High correlation |
BookingsCheckedIn is highly correlated with AverageLeadTime and 5 other fields | High correlation |
PersonsNights is highly correlated with AverageLeadTime and 3 other fields | High correlation |
RoomNights is highly correlated with AverageLeadTime and 3 other fields | High correlation |
DaysSinceLastStay is highly correlated with Unnamed: 0 and 4 other fields | High correlation |
DaysSinceFirstStay is highly correlated with Unnamed: 0 and 4 other fields | High correlation |
Total Revenue is highly correlated with BookingsCheckedIn and 2 other fields | High correlation |
MarketSegment is highly correlated with DistributionChannel | High correlation |
DistributionChannel is highly correlated with MarketSegment | High correlation |
Unnamed: 0 is highly correlated with ID and 3 other fields | High correlation |
ID is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
DaysSinceCreation is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
AverageLeadTime is highly correlated with DaysSinceLastStay and 1 other fields | High correlation |
BookingsCanceled is highly correlated with BookingsCheckedIn and 1 other fields | High correlation |
BookingsNoShowed is highly correlated with BookingsCheckedIn and 2 other fields | High correlation |
BookingsCheckedIn is highly correlated with BookingsCanceled and 4 other fields | High correlation |
PersonsNights is highly correlated with BookingsNoShowed and 3 other fields | High correlation |
RoomNights is highly correlated with BookingsCanceled and 4 other fields | High correlation |
DaysSinceLastStay is highly correlated with Unnamed: 0 and 4 other fields | High correlation |
DaysSinceFirstStay is highly correlated with Unnamed: 0 and 4 other fields | High correlation |
DistributionChannel is highly correlated with MarketSegment | High correlation |
MarketSegment is highly correlated with DistributionChannel | High correlation |
Total Revenue is highly correlated with BookingsCheckedIn and 2 other fields | High correlation |
Age has 3746 (4.5%) missing values | Missing |
BookingsCanceled is highly skewed (γ1 = 57.95186518) | Skewed |
BookingsCheckedIn is highly skewed (γ1 = 27.07036159) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
ID is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
ID has unique values | Unique |
AverageLeadTime has 22157 (26.8%) zeros | Zeros |
BookingsCanceled has 82462 (99.9%) zeros | Zeros |
BookingsCheckedIn has 19394 (23.5%) zeros | Zeros |
PersonsNights has 19396 (23.5%) zeros | Zeros |
RoomNights has 19394 (23.5%) zeros | Zeros |
Total Revenue has 19667 (23.8%) zeros | Zeros |
Reproduction
| Analysis started | 2022-09-06 16:39:30.898385 |
|---|---|
| Analysis finished | 2022-09-06 16:40:30.168443 |
| Duration | 59.27 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 82580 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41289.5 |
| Minimum | 0 |
|---|---|
| Maximum | 82579 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4128.95 |
| Q1 | 20644.75 |
| median | 41289.5 |
| Q3 | 61934.25 |
| 95-th percentile | 78450.05 |
| Maximum | 82579 |
| Range | 82579 |
| Interquartile range (IQR) | 41289.5 |
Descriptive statistics
| Standard deviation | 23838.93695 |
|---|---|
| Coefficient of variation (CV) | 0.5773607564 |
| Kurtosis | -1.2 |
| Mean | 41289.5 |
| Median Absolute Deviation (MAD) | 20645 |
| Skewness | 0 |
| Sum | 3409686910 |
| Variance | 568294915 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 55080 | 1 | < 0.1% |
| 55058 | 1 | < 0.1% |
| 55057 | 1 | < 0.1% |
| 55056 | 1 | < 0.1% |
| 55055 | 1 | < 0.1% |
| 55054 | 1 | < 0.1% |
| 55053 | 1 | < 0.1% |
| 55052 | 1 | < 0.1% |
| 55051 | 1 | < 0.1% |
| Other values (82570) | 82570 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 82579 | 1 | |
| 82578 | 1 | |
| 82577 | 1 | |
| 82576 | 1 | |
| 82575 | 1 | |
| 82574 | 1 | |
| 82573 | 1 | |
| 82572 | 1 | |
| 82571 | 1 | |
| 82570 | 1 |
ID
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 82580 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41290.5 |
| Minimum | 1 |
|---|---|
| Maximum | 82580 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4129.95 |
| Q1 | 20645.75 |
| median | 41290.5 |
| Q3 | 61935.25 |
| 95-th percentile | 78451.05 |
| Maximum | 82580 |
| Range | 82579 |
| Interquartile range (IQR) | 41289.5 |
Descriptive statistics
| Standard deviation | 23838.93695 |
|---|---|
| Coefficient of variation (CV) | 0.5773467735 |
| Kurtosis | -1.2 |
| Mean | 41290.5 |
| Median Absolute Deviation (MAD) | 20645 |
| Skewness | 0 |
| Sum | 3409769490 |
| Variance | 568294915 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 55081 | 1 | < 0.1% |
| 55059 | 1 | < 0.1% |
| 55058 | 1 | < 0.1% |
| 55057 | 1 | < 0.1% |
| 55056 | 1 | < 0.1% |
| 55055 | 1 | < 0.1% |
| 55054 | 1 | < 0.1% |
| 55053 | 1 | < 0.1% |
| 55052 | 1 | < 0.1% |
| Other values (82570) | 82570 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 82580 | 1 | |
| 82579 | 1 | |
| 82578 | 1 | |
| 82577 | 1 | |
| 82576 | 1 | |
| 82575 | 1 | |
| 82574 | 1 | |
| 82573 | 1 | |
| 82572 | 1 | |
| 82571 | 1 |
| Distinct | 188 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| FRA | |
|---|---|
| PRT | |
| DEU | |
| GBR | |
| ESP | |
| Other values (183) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 247740 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 33 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | DEU |
| 4th row | FRA |
| 5th row | FRA |
Common Values
| Value | Count | Frequency (%) |
| FRA | 12307 | |
| PRT | 11382 | |
| DEU | 10164 | |
| GBR | 8610 | |
| ESP | 4864 | 5.9% |
| USA | 3398 | 4.1% |
| ITA | 3301 | 4.0% |
| BEL | 3111 | 3.8% |
| BRA | 2710 | 3.3% |
| NLD | 2698 | 3.3% |
| Other values (178) | 20035 |
Length
| Value | Count | Frequency (%) |
| fra | 12307 | |
| prt | 11382 | |
| deu | 10164 | |
| gbr | 8610 | |
| esp | 4864 | 5.9% |
| usa | 3398 | 4.1% |
| ita | 3301 | 4.0% |
| bel | 3111 | 3.8% |
| bra | 2710 | 3.3% |
| nld | 2698 | 3.3% |
| Other values (178) | 20035 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 41541 | |
| A | 26519 | |
| E | 22239 | |
| U | 17848 | 7.2% |
| P | 17495 | 7.1% |
| T | 16755 | 6.8% |
| B | 14932 | 6.0% |
| D | 13879 | 5.6% |
| F | 13022 | 5.3% |
| S | 12285 | 5.0% |
| Other values (16) | 51225 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 247740 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 41541 | |
| A | 26519 | |
| E | 22239 | |
| U | 17848 | 7.2% |
| P | 17495 | 7.1% |
| T | 16755 | 6.8% |
| B | 14932 | 6.0% |
| D | 13879 | 5.6% |
| F | 13022 | 5.3% |
| S | 12285 | 5.0% |
| Other values (16) | 51225 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 247740 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 41541 | |
| A | 26519 | |
| E | 22239 | |
| U | 17848 | 7.2% |
| P | 17495 | 7.1% |
| T | 16755 | 6.8% |
| B | 14932 | 6.0% |
| D | 13879 | 5.6% |
| F | 13022 | 5.3% |
| S | 12285 | 5.0% |
| Other values (16) | 51225 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 247740 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 41541 | |
| A | 26519 | |
| E | 22239 | |
| U | 17848 | 7.2% |
| P | 17495 | 7.1% |
| T | 16755 | 6.8% |
| B | 14932 | 6.0% |
| D | 13879 | 5.6% |
| F | 13022 | 5.3% |
| S | 12285 | 5.0% |
| Other values (16) | 51225 |
| Distinct | 105 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 3746 |
| Missing (%) | 4.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.46855418 |
| Minimum | -11 |
|---|---|
| Maximum | 122 |
| Zeros | 40 |
| Zeros (%) | < 0.1% |
| Negative | 17 |
| Negative (%) | < 0.1% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | -11 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 34 |
| median | 46 |
| Q3 | 57 |
| 95-th percentile | 72 |
| Maximum | 122 |
| Range | 133 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 16.52627567 |
|---|---|
| Coefficient of variation (CV) | 0.3634660475 |
| Kurtosis | -0.2865254005 |
| Mean | 45.46855418 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -0.156066243 |
| Sum | 3584468 |
| Variance | 273.1177875 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 2015 | 2.4% |
| 51 | 2013 | 2.4% |
| 54 | 1965 | 2.4% |
| 53 | 1913 | 2.3% |
| 49 | 1871 | 2.3% |
| 52 | 1867 | 2.3% |
| 48 | 1858 | 2.2% |
| 55 | 1824 | 2.2% |
| 47 | 1820 | 2.2% |
| 46 | 1717 | 2.1% |
| Other values (95) | 59971 | |
| (Missing) | 3746 | 4.5% |
| Value | Count | Frequency (%) |
| -11 | 2 | < 0.1% |
| -10 | 4 | < 0.1% |
| -9 | 2 | < 0.1% |
| -7 | 3 | < 0.1% |
| -6 | 3 | < 0.1% |
| -1 | 3 | < 0.1% |
| 0 | 40 | < 0.1% |
| 1 | 105 | |
| 2 | 122 | |
| 3 | 120 |
| Value | Count | Frequency (%) |
| 122 | 1 | < 0.1% |
| 114 | 2 | < 0.1% |
| 113 | 3 | |
| 110 | 1 | < 0.1% |
| 109 | 1 | < 0.1% |
| 96 | 1 | < 0.1% |
| 92 | 3 | |
| 91 | 1 | < 0.1% |
| 90 | 2 | < 0.1% |
| 89 | 5 |
DaysSinceCreation
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 1083 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 459.1381569 |
| Minimum | 12 |
|---|---|
| Maximum | 1095 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 60 |
| Q1 | 183 |
| median | 406 |
| Q3 | 728 |
| 95-th percentile | 998 |
| Maximum | 1095 |
| Range | 1083 |
| Interquartile range (IQR) | 545 |
Descriptive statistics
| Standard deviation | 311.3092951 |
|---|---|
| Coefficient of variation (CV) | 0.6780296745 |
| Kurtosis | -1.152943924 |
| Mean | 459.1381569 |
| Median Absolute Deviation (MAD) | 249 |
| Skewness | 0.3935969279 |
| Sum | 37915629 |
| Variance | 96913.47721 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 212 | 298 | 0.4% |
| 232 | 247 | 0.3% |
| 22 | 233 | 0.3% |
| 281 | 227 | 0.3% |
| 101 | 225 | 0.3% |
| 195 | 220 | 0.3% |
| 78 | 211 | 0.3% |
| 217 | 211 | 0.3% |
| 206 | 207 | 0.3% |
| 85 | 206 | 0.2% |
| Other values (1073) | 80295 |
| Value | Count | Frequency (%) |
| 12 | 36 | < 0.1% |
| 13 | 50 | |
| 14 | 95 | |
| 15 | 124 | |
| 16 | 42 | 0.1% |
| 17 | 30 | < 0.1% |
| 18 | 39 | < 0.1% |
| 19 | 26 | < 0.1% |
| 20 | 50 | |
| 21 | 82 |
| Value | Count | Frequency (%) |
| 1095 | 70 | |
| 1094 | 90 | |
| 1093 | 103 | |
| 1092 | 16 | < 0.1% |
| 1091 | 99 | |
| 1090 | 21 | < 0.1% |
| 1089 | 10 | < 0.1% |
| 1088 | 15 | < 0.1% |
| 1087 | 5 | < 0.1% |
| 1086 | 20 | < 0.1% |
| Distinct | 418 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66.55720513 |
| Minimum | -1 |
|---|---|
| Maximum | 588 |
| Zeros | 22157 |
| Zeros (%) | 26.8% |
| Negative | 10 |
| Negative (%) | < 0.1% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 30 |
| Q3 | 104 |
| 95-th percentile | 241 |
| Maximum | 588 |
| Range | 589 |
| Interquartile range (IQR) | 104 |
Descriptive statistics
| Standard deviation | 87.92899502 |
|---|---|
| Coefficient of variation (CV) | 1.321104076 |
| Kurtosis | 4.464738599 |
| Mean | 66.55720513 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 1.906882747 |
| Sum | 5496294 |
| Variance | 7731.508165 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 22157 | |
| 1 | 1693 | 2.1% |
| 2 | 1051 | 1.3% |
| 6 | 1040 | 1.3% |
| 5 | 1014 | 1.2% |
| 4 | 1000 | 1.2% |
| 3 | 965 | 1.2% |
| 7 | 953 | 1.2% |
| 8 | 903 | 1.1% |
| 9 | 670 | 0.8% |
| Other values (408) | 51134 |
| Value | Count | Frequency (%) |
| -1 | 10 | < 0.1% |
| 0 | 22157 | |
| 1 | 1693 | 2.1% |
| 2 | 1051 | 1.3% |
| 3 | 965 | 1.2% |
| 4 | 1000 | 1.2% |
| 5 | 1014 | 1.2% |
| 6 | 1040 | 1.3% |
| 7 | 953 | 1.2% |
| 8 | 903 | 1.1% |
| Value | Count | Frequency (%) |
| 588 | 19 | |
| 574 | 10 | |
| 549 | 22 | |
| 546 | 10 | |
| 543 | 2 | < 0.1% |
| 542 | 5 | < 0.1% |
| 541 | 5 | < 0.1% |
| 535 | 21 | |
| 533 | 1 | < 0.1% |
| 521 | 11 |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.002046500363 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 82462 |
| Zeros (%) | 99.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.06717662276 |
|---|---|
| Coefficient of variation (CV) | 32.82512135 |
| Kurtosis | 5207.131053 |
| Mean | 0.002046500363 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 57.95186518 |
| Sum | 169 |
| Variance | 0.004512698645 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 82462 | |
| 1 | 92 | 0.1% |
| 2 | 12 | < 0.1% |
| 3 | 8 | < 0.1% |
| 4 | 5 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 82462 | |
| 1 | 92 | 0.1% |
| 2 | 12 | < 0.1% |
| 3 | 8 | < 0.1% |
| 4 | 5 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 1 | < 0.1% |
| 4 | 5 | < 0.1% |
| 3 | 8 | < 0.1% |
| 2 | 12 | < 0.1% |
| 1 | 92 | 0.1% |
| 0 | 82462 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 36 |
| 2 | 7 |
| 3 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82536 | |
| 1 | 36 | < 0.1% |
| 2 | 7 | < 0.1% |
| 3 | 1 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82536 | |
| 1 | 36 | < 0.1% |
| 2 | 7 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82536 | |
| 1 | 36 | < 0.1% |
| 2 | 7 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82536 | |
| 1 | 36 | < 0.1% |
| 2 | 7 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82536 | |
| 1 | 36 | < 0.1% |
| 2 | 7 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82536 | |
| 1 | 36 | < 0.1% |
| 2 | 7 | < 0.1% |
| 3 | 1 | < 0.1% |
BookingsCheckedIn
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.79840155 |
| Minimum | 0 |
|---|---|
| Maximum | 66 |
| Zeros | 19394 |
| Zeros (%) | 23.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 66 |
| Range | 66 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6968798281 |
|---|---|
| Coefficient of variation (CV) | 0.8728437816 |
| Kurtosis | 1847.105958 |
| Mean | 0.79840155 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 27.07036159 |
| Sum | 65932 |
| Variance | 0.4856414949 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 61737 | |
| 0 | 19394 | 23.5% |
| 2 | 1141 | 1.4% |
| 3 | 132 | 0.2% |
| 4 | 59 | 0.1% |
| 5 | 20 | < 0.1% |
| 6 | 20 | < 0.1% |
| 7 | 16 | < 0.1% |
| 8 | 10 | < 0.1% |
| 9 | 9 | < 0.1% |
| Other values (19) | 42 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 19394 | 23.5% |
| 1 | 61737 | |
| 2 | 1141 | 1.4% |
| 3 | 132 | 0.2% |
| 4 | 59 | 0.1% |
| 5 | 20 | < 0.1% |
| 6 | 20 | < 0.1% |
| 7 | 16 | < 0.1% |
| 8 | 10 | < 0.1% |
| 9 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 66 | 1 | < 0.1% |
| 57 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| 29 | 3 | |
| 26 | 1 | < 0.1% |
| 25 | 1 | < 0.1% |
| 24 | 1 | < 0.1% |
| 23 | 2 | |
| 20 | 1 | < 0.1% |
PersonsNights
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 56 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.667958343 |
| Minimum | 0 |
|---|---|
| Maximum | 116 |
| Zeros | 19396 |
| Zeros (%) | 23.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 4 |
| Q3 | 7 |
| 95-th percentile | 12 |
| Maximum | 116 |
| Range | 116 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.562507174 |
|---|---|
| Coefficient of variation (CV) | 0.9774095737 |
| Kurtosis | 12.60176786 |
| Mean | 4.667958343 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.935882185 |
| Sum | 385480 |
| Variance | 20.81647172 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19396 | |
| 6 | 13639 | |
| 4 | 10366 | |
| 2 | 9512 | |
| 8 | 8199 | |
| 1 | 4109 | 5.0% |
| 3 | 3996 | 4.8% |
| 10 | 3434 | 4.2% |
| 12 | 3055 | 3.7% |
| 9 | 1830 | 2.2% |
| Other values (46) | 5044 | 6.1% |
| Value | Count | Frequency (%) |
| 0 | 19396 | |
| 1 | 4109 | 5.0% |
| 2 | 9512 | |
| 3 | 3996 | 4.8% |
| 4 | 10366 | |
| 5 | 898 | 1.1% |
| 6 | 13639 | |
| 7 | 221 | 0.3% |
| 8 | 8199 | |
| 9 | 1830 | 2.2% |
| Value | Count | Frequency (%) |
| 116 | 1 | |
| 78 | 1 | |
| 75 | 1 | |
| 73 | 1 | |
| 68 | 2 | |
| 62 | 1 | |
| 59 | 1 | |
| 56 | 1 | |
| 52 | 1 | |
| 51 | 1 |
RoomNights
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 48 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.36941148 |
| Minimum | 0 |
|---|---|
| Maximum | 185 |
| Zeros | 19394 |
| Zeros (%) | 23.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 185 |
| Range | 185 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2817575 |
|---|---|
| Coefficient of variation (CV) | 0.9630060121 |
| Kurtosis | 655.3970849 |
| Mean | 2.36941148 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 11.30982346 |
| Sum | 195666 |
| Variance | 5.20641729 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19394 | |
| 3 | 17084 | |
| 2 | 14031 | |
| 1 | 11231 | |
| 4 | 11083 | |
| 5 | 4997 | 6.1% |
| 7 | 1915 | 2.3% |
| 6 | 1830 | 2.2% |
| 8 | 368 | 0.4% |
| 9 | 195 | 0.2% |
| Other values (38) | 452 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 19394 | |
| 1 | 11231 | |
| 2 | 14031 | |
| 3 | 17084 | |
| 4 | 11083 | |
| 5 | 4997 | 6.1% |
| 6 | 1830 | 2.2% |
| 7 | 1915 | 2.3% |
| 8 | 368 | 0.4% |
| 9 | 195 | 0.2% |
| Value | Count | Frequency (%) |
| 185 | 1 | |
| 116 | 1 | |
| 95 | 1 | |
| 88 | 1 | |
| 66 | 1 | |
| 59 | 1 | |
| 51 | 1 | |
| 49 | 1 | |
| 42 | 1 | |
| 40 | 1 |
DaysSinceLastStay
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 1100 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 405.9354565 |
| Minimum | -1 |
|---|---|
| Maximum | 1104 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 19394 |
| Negative (%) | 23.5% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 42 |
| median | 378 |
| Q3 | 698 |
| 95-th percentile | 982 |
| Maximum | 1104 |
| Range | 1105 |
| Interquartile range (IQR) | 656 |
Descriptive statistics
| Standard deviation | 346.5023411 |
|---|---|
| Coefficient of variation (CV) | 0.8535897407 |
| Kurtosis | -1.289002372 |
| Mean | 405.9354565 |
| Median Absolute Deviation (MAD) | 330 |
| Skewness | 0.2920894444 |
| Sum | 33522150 |
| Variance | 120063.8724 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -1 | 19394 | 23.5% |
| 920 | 203 | 0.2% |
| 472 | 196 | 0.2% |
| 477 | 165 | 0.2% |
| 938 | 158 | 0.2% |
| 97 | 156 | 0.2% |
| 192 | 144 | 0.2% |
| 217 | 144 | 0.2% |
| 442 | 126 | 0.2% |
| 206 | 126 | 0.2% |
| Other values (1090) | 61768 |
| Value | Count | Frequency (%) |
| -1 | 19394 | |
| 2 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 4 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 3 | < 0.1% |
| 10 | 1 | < 0.1% |
| 11 | 3 | < 0.1% |
| 12 | 6 | < 0.1% |
| 13 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 1104 | 3 | < 0.1% |
| 1102 | 1 | < 0.1% |
| 1101 | 2 | < 0.1% |
| 1100 | 12 | < 0.1% |
| 1099 | 12 | < 0.1% |
| 1098 | 36 | |
| 1097 | 44 | |
| 1096 | 37 | |
| 1095 | 14 | < 0.1% |
| 1094 | 55 |
DaysSinceFirstStay
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 1096 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 408.2450714 |
| Minimum | -1 |
|---|---|
| Maximum | 1186 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 19394 |
| Negative (%) | 23.5% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 44 |
| median | 388 |
| Q3 | 705 |
| 95-th percentile | 983 |
| Maximum | 1186 |
| Range | 1187 |
| Interquartile range (IQR) | 661 |
Descriptive statistics
| Standard deviation | 347.2471272 |
|---|---|
| Coefficient of variation (CV) | 0.850584983 |
| Kurtosis | -1.295653749 |
| Mean | 408.2450714 |
| Median Absolute Deviation (MAD) | 333 |
| Skewness | 0.2832263141 |
| Sum | 33712878 |
| Variance | 120580.5673 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -1 | 19394 | 23.5% |
| 920 | 203 | 0.2% |
| 472 | 203 | 0.2% |
| 477 | 161 | 0.2% |
| 938 | 157 | 0.2% |
| 97 | 149 | 0.2% |
| 217 | 140 | 0.2% |
| 192 | 139 | 0.2% |
| 442 | 125 | 0.2% |
| 206 | 124 | 0.2% |
| Other values (1086) | 61785 |
| Value | Count | Frequency (%) |
| -1 | 19394 | |
| 13 | 7 | < 0.1% |
| 14 | 26 | < 0.1% |
| 15 | 15 | < 0.1% |
| 16 | 33 | < 0.1% |
| 17 | 41 | < 0.1% |
| 18 | 36 | < 0.1% |
| 19 | 24 | < 0.1% |
| 20 | 20 | < 0.1% |
| 21 | 42 | 0.1% |
| Value | Count | Frequency (%) |
| 1186 | 1 | < 0.1% |
| 1117 | 1 | < 0.1% |
| 1116 | 1 | < 0.1% |
| 1111 | 1 | < 0.1% |
| 1104 | 3 | < 0.1% |
| 1102 | 1 | < 0.1% |
| 1101 | 2 | < 0.1% |
| 1100 | 12 | < 0.1% |
| 1099 | 12 | < 0.1% |
| 1098 | 36 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| Travel Agent/Operator | |
|---|---|
| Direct | |
| Corporate | 2565 |
| Electronic Distribution | 508 |
Length
| Max length | 23 |
|---|---|
| Median length | 21 |
| Mean length | 18.51272705 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1528781 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Corporate |
|---|---|
| 2nd row | Travel Agent/Operator |
| 3rd row | Travel Agent/Operator |
| 4th row | Travel Agent/Operator |
| 5th row | Travel Agent/Operator |
Common Values
| Value | Count | Frequency (%) |
| Travel Agent/Operator | 67798 | |
| Direct | 11709 | 14.2% |
| Corporate | 2565 | 3.1% |
| Electronic Distribution | 508 | 0.6% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| travel | 67798 | |
| agent/operator | 67798 | |
| direct | 11709 | 7.8% |
| corporate | 2565 | 1.7% |
| electronic | 508 | 0.3% |
| distribution | 508 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 221249 | |
| e | 218176 | |
| t | 151394 | 9.9% |
| a | 138161 | 9.0% |
| o | 73944 | 4.8% |
| p | 70363 | 4.6% |
| n | 68814 | 4.5% |
| l | 68306 | 4.5% |
| 68306 | 4.5% | |
| T | 67798 | 4.4% |
| Other values (13) | 382270 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1173993 | |
| Uppercase Letter | 218684 | 14.3% |
| Space Separator | 68306 | 4.5% |
| Other Punctuation | 67798 | 4.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 221249 | |
| e | 218176 | |
| t | 151394 | |
| a | 138161 | |
| o | 73944 | 6.3% |
| p | 70363 | 6.0% |
| n | 68814 | 5.9% |
| l | 68306 | 5.8% |
| g | 67798 | 5.8% |
| v | 67798 | 5.8% |
| Other values (5) | 27990 | 2.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 67798 | |
| O | 67798 | |
| A | 67798 | |
| D | 12217 | 5.6% |
| C | 2565 | 1.2% |
| E | 508 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 68306 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 67798 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1392677 | |
| Common | 136104 | 8.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 221249 | |
| e | 218176 | |
| t | 151394 | |
| a | 138161 | |
| o | 73944 | 5.3% |
| p | 70363 | 5.1% |
| n | 68814 | 4.9% |
| l | 68306 | 4.9% |
| T | 67798 | 4.9% |
| O | 67798 | 4.9% |
| Other values (11) | 246674 |
Common
| Value | Count | Frequency (%) |
| 68306 | ||
| / | 67798 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1528781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 221249 | |
| e | 218176 | |
| t | 151394 | 9.9% |
| a | 138161 | 9.0% |
| o | 73944 | 4.8% |
| p | 70363 | 4.6% |
| n | 68814 | 4.5% |
| l | 68306 | 4.5% |
| 68306 | 4.5% | |
| T | 67798 | 4.4% |
| Other values (13) | 382270 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| Other | |
|---|---|
| Travel Agent/Operator | |
| Direct | |
| Groups | |
| Corporate | 2135 |
| Other values (2) | 727 |
Length
| Max length | 21 |
|---|---|
| Median length | 5 |
| Mean length | 7.635408089 |
| Min length | 5 |
Characters and Unicode
| Total characters | 630532 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Corporate |
|---|---|
| 2nd row | Travel Agent/Operator |
| 3rd row | Travel Agent/Operator |
| 4th row | Travel Agent/Operator |
| 5th row | Travel Agent/Operator |
Common Values
| Value | Count | Frequency (%) |
| Other | 47457 | |
| Travel Agent/Operator | 11482 | 13.9% |
| Direct | 11278 | 13.7% |
| Groups | 9501 | 11.5% |
| Corporate | 2135 | 2.6% |
| Complementary | 484 | 0.6% |
| Aviation | 243 | 0.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| other | 47457 | |
| travel | 11482 | 12.2% |
| agent/operator | 11482 | 12.2% |
| direct | 11278 | 12.0% |
| groups | 9501 | 10.1% |
| corporate | 2135 | 2.3% |
| complementary | 484 | 0.5% |
| aviation | 243 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 107436 | |
| e | 96284 | |
| t | 84561 | |
| O | 58939 | |
| h | 47457 | 7.5% |
| o | 25980 | 4.1% |
| a | 25826 | 4.1% |
| p | 23602 | 3.7% |
| n | 12209 | 1.9% |
| l | 11966 | 1.9% |
| Other values (15) | 136272 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 502024 | |
| Uppercase Letter | 105544 | 16.7% |
| Space Separator | 11482 | 1.8% |
| Other Punctuation | 11482 | 1.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 107436 | |
| e | 96284 | |
| t | 84561 | |
| h | 47457 | |
| o | 25980 | 5.2% |
| a | 25826 | 5.1% |
| p | 23602 | 4.7% |
| n | 12209 | 2.4% |
| l | 11966 | 2.4% |
| i | 11764 | 2.3% |
| Other values (7) | 54939 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 58939 | |
| A | 11725 | 11.1% |
| T | 11482 | 10.9% |
| D | 11278 | 10.7% |
| G | 9501 | 9.0% |
| C | 2619 | 2.5% |
Space Separator
| Value | Count | Frequency (%) |
| 11482 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 11482 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 607568 | |
| Common | 22964 | 3.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 107436 | |
| e | 96284 | |
| t | 84561 | |
| O | 58939 | |
| h | 47457 | |
| o | 25980 | 4.3% |
| a | 25826 | 4.3% |
| p | 23602 | 3.9% |
| n | 12209 | 2.0% |
| l | 11966 | 2.0% |
| Other values (13) | 113308 |
Common
| Value | Count | Frequency (%) |
| 11482 | ||
| / | 11482 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 630532 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 107436 | |
| e | 96284 | |
| t | 84561 | |
| O | 58939 | |
| h | 47457 | 7.5% |
| o | 25980 | 4.1% |
| a | 25826 | 4.1% |
| p | 23602 | 3.7% |
| n | 12209 | 1.9% |
| l | 11966 | 1.9% |
| Other values (15) | 136272 |
SRHighFloor
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 3924 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 78656 | |
| 1 | 3924 | 4.8% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 78656 | |
| 1 | 3924 | 4.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 78656 | |
| 1 | 3924 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 78656 | |
| 1 | 3924 | 4.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 78656 | |
| 1 | 3924 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 78656 | |
| 1 | 3924 | 4.8% |
SRLowFloor
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 118 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82462 | |
| 1 | 118 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82462 | |
| 1 | 118 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82462 | |
| 1 | 118 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82462 | |
| 1 | 118 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82462 | |
| 1 | 118 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82462 | |
| 1 | 118 | 0.1% |
SRAccessibleRoom
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 21 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82559 | |
| 1 | 21 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82559 | |
| 1 | 21 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82559 | |
| 1 | 21 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82559 | |
| 1 | 21 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82559 | |
| 1 | 21 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82559 | |
| 1 | 21 | < 0.1% |
SRMediumFloor
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 73 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82507 | |
| 1 | 73 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82507 | |
| 1 | 73 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82507 | |
| 1 | 73 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82507 | |
| 1 | 73 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82507 | |
| 1 | 73 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82507 | |
| 1 | 73 | 0.1% |
SRBathtub
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 232 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82348 | |
| 1 | 232 | 0.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82348 | |
| 1 | 232 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82348 | |
| 1 | 232 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82348 | |
| 1 | 232 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82348 | |
| 1 | 232 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82348 | |
| 1 | 232 | 0.3% |
SRShower
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 143 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82437 | |
| 1 | 143 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82437 | |
| 1 | 143 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82437 | |
| 1 | 143 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82437 | |
| 1 | 143 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82437 | |
| 1 | 143 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82437 | |
| 1 | 143 | 0.2% |
SRCrib
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 1058 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 81522 | |
| 1 | 1058 | 1.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 81522 | |
| 1 | 1058 | 1.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 81522 | |
| 1 | 1058 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 81522 | |
| 1 | 1058 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 81522 | |
| 1 | 1058 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 81522 | |
| 1 | 1058 | 1.3% |
SRKingSizeBed
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 53539 | |
| 1 | 29041 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 53539 | |
| 1 | 29041 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 53539 | |
| 1 | 29041 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 53539 | |
| 1 | 29041 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 53539 | |
| 1 | 29041 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 53539 | |
| 1 | 29041 |
SRTwinBed
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 70790 | |
| 1 | 11790 | 14.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 70790 | |
| 1 | 11790 | 14.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 70790 | |
| 1 | 11790 | 14.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 70790 | |
| 1 | 11790 | 14.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 70790 | |
| 1 | 11790 | 14.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 70790 | |
| 1 | 11790 | 14.3% |
SRNearElevator
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 25 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82555 | |
| 1 | 25 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82555 | |
| 1 | 25 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82555 | |
| 1 | 25 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82555 | |
| 1 | 25 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82555 | |
| 1 | 25 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82555 | |
| 1 | 25 | < 0.1% |
SRAwayFromElevator
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 293 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82287 | |
| 1 | 293 | 0.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82287 | |
| 1 | 293 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82287 | |
| 1 | 293 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82287 | |
| 1 | 293 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82287 | |
| 1 | 293 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82287 | |
| 1 | 293 | 0.4% |
SRNoAlcoholInMiniBar
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 10 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 82570 | |
| 1 | 10 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 82570 | |
| 1 | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 82570 | |
| 1 | 10 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82570 | |
| 1 | 10 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 82570 | |
| 1 | 10 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 82570 | |
| 1 | 10 | < 0.1% |
SRQuietRoom
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 645.3 KiB |
| 0 | |
|---|---|
| 1 | 7272 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82580 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 75308 | |
| 1 | 7272 | 8.8% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 75308 | |
| 1 | 7272 | 8.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 75308 | |
| 1 | 7272 | 8.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 82580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 75308 | |
| 1 | 7272 | 8.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 75308 | |
| 1 | 7272 | 8.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 75308 | |
| 1 | 7272 | 8.8% |
Total Revenue
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 16637 |
|---|---|
| Distinct (%) | 20.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 368.3473957 |
| Minimum | 0 |
|---|---|
| Maximum | 23365 |
| Zeros | 19667 |
| Zeros (%) | 23.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 645.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 80 |
| median | 289 |
| Q3 | 498.75 |
| 95-th percentile | 1084.5 |
| Maximum | 23365 |
| Range | 23365 |
| Interquartile range (IQR) | 418.75 |
Descriptive statistics
| Standard deviation | 444.2943523 |
|---|---|
| Coefficient of variation (CV) | 1.206182961 |
| Kurtosis | 131.0727867 |
| Mean | 368.3473957 |
| Median Absolute Deviation (MAD) | 209.5 |
| Skewness | 5.789490849 |
| Sum | 30418127.94 |
| Variance | 197397.4715 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19667 | 23.8% |
| 234 | 295 | 0.4% |
| 248.8 | 205 | 0.2% |
| 302 | 199 | 0.2% |
| 182 | 189 | 0.2% |
| 359 | 187 | 0.2% |
| 81 | 184 | 0.2% |
| 162 | 172 | 0.2% |
| 344 | 171 | 0.2% |
| 242 | 171 | 0.2% |
| Other values (16627) | 61140 |
| Value | Count | Frequency (%) |
| 0 | 19667 | |
| 1 | 3 | < 0.1% |
| 2 | 15 | < 0.1% |
| 2.5 | 3 | < 0.1% |
| 3 | 10 | < 0.1% |
| 3.5 | 1 | < 0.1% |
| 4 | 17 | < 0.1% |
| 4.5 | 1 | < 0.1% |
| 5 | 6 | < 0.1% |
| 5.5 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 23365 | 1 | |
| 11930.66 | 1 | |
| 11081.15 | 1 | |
| 10982.4 | 1 | |
| 10324.5 | 1 | |
| 9576.8 | 1 | |
| 9188.75 | 1 | |
| 8607 | 1 | |
| 8110.98 | 1 | |
| 8003 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Unnamed: 0 | ID | Nationality | Age | DaysSinceCreation | AverageLeadTime | BookingsCanceled | BookingsNoShowed | BookingsCheckedIn | PersonsNights | RoomNights | DaysSinceLastStay | DaysSinceFirstStay | DistributionChannel | MarketSegment | SRHighFloor | SRLowFloor | SRAccessibleRoom | SRMediumFloor | SRBathtub | SRShower | SRCrib | SRKingSizeBed | SRTwinBed | SRNearElevator | SRAwayFromElevator | SRNoAlcoholInMiniBar | SRQuietRoom | Total Revenue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1 | PRT | 51.0 | 150 | 45 | 1 | 0 | 3 | 8 | 5 | 151 | 1074 | Corporate | Corporate | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 476.3 |
| 1 | 1 | 2 | PRT | NaN | 1095 | 61 | 0 | 0 | 1 | 10 | 5 | 1100 | 1100 | Travel Agent/Operator | Travel Agent/Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 333.0 |
| 2 | 2 | 3 | DEU | 31.0 | 1095 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | Travel Agent/Operator | Travel Agent/Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 |
| 3 | 3 | 4 | FRA | 60.0 | 1095 | 93 | 0 | 0 | 1 | 10 | 5 | 1100 | 1100 | Travel Agent/Operator | Travel Agent/Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300.0 |
| 4 | 4 | 5 | FRA | 51.0 | 1095 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | Travel Agent/Operator | Travel Agent/Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 |
| 5 | 5 | 6 | JPN | 54.0 | 1095 | 58 | 0 | 0 | 1 | 4 | 2 | 1097 | 1097 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 254.0 |
| 6 | 6 | 7 | JPN | 49.0 | 1095 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 |
| 7 | 7 | 8 | FRA | 32.0 | 1095 | 38 | 0 | 0 | 1 | 10 | 5 | 1100 | 1100 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 629.0 |
| 8 | 8 | 9 | FRA | 42.0 | 1095 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.0 |
| 9 | 9 | 10 | IRL | 25.0 | 1095 | 96 | 0 | 0 | 1 | 6 | 3 | 1098 | 1098 | Travel Agent/Operator | Travel Agent/Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 243.0 |
Last rows
| Unnamed: 0 | ID | Nationality | Age | DaysSinceCreation | AverageLeadTime | BookingsCanceled | BookingsNoShowed | BookingsCheckedIn | PersonsNights | RoomNights | DaysSinceLastStay | DaysSinceFirstStay | DistributionChannel | MarketSegment | SRHighFloor | SRLowFloor | SRAccessibleRoom | SRMediumFloor | SRBathtub | SRShower | SRCrib | SRKingSizeBed | SRTwinBed | SRNearElevator | SRAwayFromElevator | SRNoAlcoholInMiniBar | SRQuietRoom | Total Revenue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82570 | 82570 | 82571 | ROU | 37.0 | 12 | 64 | 0 | 0 | 1 | 8 | 4 | 16 | 16 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 409.20 |
| 82571 | 82571 | 82572 | ROU | 36.0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 |
| 82572 | 82572 | 82573 | FRA | 32.0 | 12 | 88 | 0 | 0 | 1 | 4 | 2 | 14 | 14 | Travel Agent/Operator | Travel Agent/Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 154.00 |
| 82573 | 82573 | 82574 | FRA | 34.0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | Travel Agent/Operator | Travel Agent/Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 |
| 82574 | 82574 | 82575 | PRT | 41.0 | 12 | 7 | 0 | 0 | 1 | 1 | 1 | 13 | 13 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82.18 |
| 82575 | 82575 | 82576 | SWE | 51.0 | 12 | 114 | 0 | 0 | 1 | 6 | 3 | 15 | 15 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 196.08 |
| 82576 | 82576 | 82577 | SWE | 50.0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.00 |
| 82577 | 82577 | 82578 | DEU | 50.0 | 12 | 18 | 0 | 0 | 1 | 3 | 3 | 15 | 15 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 477.00 |
| 82578 | 82578 | 82579 | PRT | NaN | 12 | 11 | 0 | 0 | 1 | 3 | 3 | 15 | 15 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 264.00 |
| 82579 | 82579 | 82580 | DEU | 17.0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | Travel Agent/Operator | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 |